drop table ForumPosts_BkUp
go

alter table dbo.ForumPosts alter column Summary nvarchar(2000) null
go

declare @count1 int
       ,@count2 int

select @count1 = count(*) from dbo.ForumPosts

select @count1

select *
into   dbo.ForumPosts_BkUp
from   dbo.ForumPosts

select @count2 = count(*) from dbo.ForumPosts_BkUp

select @count2

if @count1 = @count2
begin
   alter table dbo.ForumPosts drop column CreateUser
   alter table dbo.ForumPosts add PartnerID int
   alter table dbo.ForumPosts add OriginAuthor nvarchar(200)
   alter table dbo.ForumPosts add URL varchar(1000)
   alter table dbo.ForumPosts add OriginalDate datetime
   alter table dbo.ForumPosts add LastModifiedBy nvarchar(256)
   alter table dbo.ForumPosts add LastModifiedDateTime datetime
end


